Emerging skills and
technologies
Manujith P
28-11-2020
1
Table of Contents
• Executive Summary
• Introduction
• Methodology
• Results
• Visualization – Charts
• Dashboard
• Discussion
• Findings & Implications
• Conclusion
• Appendix
2
Executive Summary
• This presentation will present the analysis report that
investigates the emerging skill set and technologies of
the IT industry.
• The primary aim of the analysis is to identify the
emerging trends in the IT industry pertaining to -
• Programming languages
• Databases
• Software platforms (IDEs)
• Web frames
• The current trends are also analyzed for comparison
with expected future trends.
3
Introduction
• The main purpose of this analysis is to keep up with
the changing tools used in the IT industry.
• This practice is necessary to identify and hire future
employees and train current employees in these tools
to keep them up to date.
• The required data is collected from various sources -
• Job postings
• Training portals
• Surveys
4
Methodology
• The required data for analysis is collected from
• GitHub jobs
• IBM website
• Stack Overflow
• The information on the number of job postings for
software tools was extracted by accessing GitHub Job APIs
• The information on the annual salaries of professionals
working with certain software tools was accessed by web
scrapping the IBM website.
• The required data set for this analysis comes from a survey
conducted by Stack Overflow which they have open
sourced.
5
Methodology
• Once the data is collected, data wrangling is performed to -
• Find missing values
• Find duplicate values
• Remove duplicates
• Determine the missing values
• Normalize the data
• After the data set is cleaned, an exploratory analysis is
conducted to identify distribution of data, outliers in any
fields and correlations between different fields.
• The data is visualized to view the distribution of data,
relationship between different fields, comparison and
composition of data.
• Finally dashboards are created to identify trends.
6
Result
• After data wrangling, the
following observations were
made –
• Most respondents earned
salaries within 250,000
USD
7
Result
• After data wrangling, the
following observations were
made –
• Most respondents were
from 20 to 45 years of age
8
Result
• After data wrangling, the
following observations were
made –
• There is a positive
correlation between the
salary and age of the
respondent.
• This makes sense as the
respondent is older in age,
the more experienced
he/she is, hence a higher
pay cheque.
9
Result
• After data wrangling, the following observations were made –
• The below table gives the correlation between different fields from the data set.
• And once again we see that Age has the strongest correlation with salary
(ConvertedComp)
10
Programming language trends
11
Programming language trends
12
Programming language trends – Findings & implications
Findings
• Java scrip and HTML/CSS
remain the most in demand
programming language
• Increasing number of
professionals want to learn
python and type script
Implications
• Hiring and training professionals
in Java and HTML will remain a
top priority
• Hiring and training professionals
in python can help the company
keep up with market trends
13
Database trends
14
Database trends
15
Database trends – Findings & implications
Findings
• MySQL is the most widely used
database
• Increasing number of
professionals want to work with
PostgreSQL and MongoDB
Implications
• Hiring and training employees in
MySQL will remain as it is,
since most employees already
work with MySQL.
• Hiring and training employees in
PostgreSQL and MongoDB must
be a priority henceforth.
16
Dashboard – Current technology usage
18
Dashboard – Future technology trend
19
Dashboard – Demographics
20
Discussion
• The main purpose of the analysis is
to identify emerging technology
trends in the IT industry.
• The trends have been analyzed and
visualized.
• Most respondents earn within
250,000 USD and are from 20 to 45
years of age, this observation
confirms the relevance of our
analysis.
• It is also important to note that
most respondents are men and
from the United States of America.
21
Overall findings and implications
Findings
• Java scrip, HTML/CSS and
MySQL remain the most in demand
tools
• Increasing number of professionals
want to learn python, type script,
PostgreSQL and MongoDB
• Linux, Windows and Docker are
the most commonly used software
platforms
• React, AngularJS and JQuery are
the most commonly used Web
frameworks
Implications
• Hiring and training professionals in
Java, HTML and MySQL will
remain a top priority
• Hiring and training professionals in
python, PostgreSQL and MongoDB
can help the company keep up with
market trends
• Professionals used to Linux and
windows, and proficient in React
and JQuery are preferred
22
Conclusion
• All in all the analysis indicates the following
tools to be the most in demand software
applications –
Programming
languages -
• JavaScript
• HTML/CSS
• Python
Databases -
• PostgreSQL
• MongoDB
• MySQL
Software Platforms -
• Windows
• Linux
• Docker
Web Frameworks -
1. JQuery
2. React
3. AngularJS
23
Appendix
• There are some interesting observations
from the GitHub job postings and the
popular languages data set that is worth
noting.
24
GitHub job postings
0 20 40 60 80 100 120 140 160 180
MongoDB
MySQL Server
Oracle
C%23
PostgreSQL
SQL Server
C%2B%2B
Scala
Python
JavaScript
Java
C
Number of job postings from GitHub
• GitHub job
postings data has
something to add
• The number of job
postings for C and
Java are the
highest, although
C wasn’t in the
top 5
programming
languages in the
analysis
25
Popular programming languages
• From the popular
programming
languages data, we
see that
professionals who
work with Swift,
python and C++ are
the highest paid
• This piece of
information is
interesting as Swift
and C++ weren’t in
the top 5
programming
languages in the
conducted analysis
$0 $20,000 $40,000 $60,000 $80,000 $100,000 $120,000 $140,000
PHP
SQL
C#
R
Go
Java
Javascript
C++
Python
Swift
Average Annual Salary
26
